Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 include("connect.php");
3 ?>
4 <?php
5 error_reporting(0);
6 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
7 ?>
8 <?php
9 session_start();
10 if (!isset($_SESSION['username']) || ($_SESSION['password'] == '')) {
11 header("location:index.php");
12 exit();
13
14 }
15 ?>
16 <?php
17 $id = $_GET['id'];
18 $select = "SELECT * FROM
19 admin
20 WHERE admin_id= $id";
21
22 $result = mysqli_fetch_array(mysqli_query($conn,$select));
23 $qry=mysqli_query($conn,$select);
24 if($qry)
25 {
26 while($rec = mysqli_fetch_array($qry)){
27 $fname = "$rec[fname]";
28 $lname = "$rec[lname]";
29 $uname = "$rec[username]";
30 $email = "$rec[email]";
31 }
32 }
33 //diri na mah submit ang data. lantawun nia kung mai onud ang every txtbox
34 if (isset($_POST['update'])){
35 if (($_POST['fname'] == '')or($_POST['lname'] == '')or($_POST['username'] == '')or ($_POST['email'] == '')or ($_POST['password'] == ''))
36 {
37 echo "You Must Fill All";
38 }
39 else{ //dri namn is ang mga "name=tenant_id" nga ara sa mga input type.
40 $f = addslashes("$_POST[fname]");
41 $l = addslashes("$_POST[lname]");
42 $un = addslashes("$_POST[username]");
43 $email = addslashes("$_POST[email]");
44 $pw = addslashes("$_POST[password]");
45 //dri nah mah edit xng data
46 mysqli_query($conn,"UPDATE admin SET fname ='$f', lname ='$l',
47 username ='$un',email ='$email',password ='$pw' WHERE admin_id = '$id'")or die(mysqli_error());
48
49 }
50 ?>
51 <script>
52 alert('Updated Successfully');
53 window.location = "manage_account.php";
54 </script>
55 <?php
56 }?>
57 <?php
58 SESSION_START();
59 ?>
60 <!DOCTYPE html>
61 <html>
62 <head>
63 <meta charset="utf-8">
64 <meta name="viewport" content="width=device-width, initial-scale=1.0">
65 <title>school management system</title>
66 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
67 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
68 <link href="assets/css/loader.css" rel="stylesheet" />
69 <script src="assets/js/canvasjs.min.js"></script>
70 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
71 <script src="assets/js/jquery-3.2.1.js"></script>
72
73
74 </head>
75 <!--<style type="text/css">
76 body{
77 margin-right: 10px;
78 margin-left: 10px;
79 }
80 </style>
81
82 -->
83
84 <body >
85 <!--end of heading section-->
86 <ul class="nav navbar-right top-nav">
87 <div class="dropdown">
88 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
89 <?php
90 //Check to see if the user is logged in.if not redirect user to the loging page.
91
92 if(isset($_SESSION['fname']))
93 {
94 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
95 }else{
96 echo "<script type='text/javascript'>
97 alert( 'You must Log in to use the system');
98 </script>";
99 echo "<script>
100 window.location = 'index.php'
101 </script>";
102 }
103 ?>
104 <span class="caret"></span></button>
105 <ul class="dropdown-menu">
106 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
107 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
108 <li class="divider"></li>
109 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
110 </ul>
111 </div>
112 </ul>
113 <!--************************************************-->
114 <div style="
115 font-family:Nyala, Arial;
116 text-align: left;
117 background-color: #526F35;
118 padding: 20px;
119 color:white;
120 width: 100%;
121 height: 150px;">
122 <!--This codes to load the image loader-->
123 <div id="loading">
124 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
125 </div>
126 <!--this is the heading section-->
127 <h2>
128 <?php
129 $sql="SELECT * FROM companyinfo";
130 $result=mysqli_query($db,$sql) or die("error getting data");
131 $num_rows=mysqli_num_rows($result);
132 while($row=mysqli_fetch_array($result))
133 {
134 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
135 $cname = $row['cname'];
136 $cemail = $row['cemail'];
137 $ccontact = $row['ccontact'];
138 $clocation = $row['clocation'];
139 }?>
140 <?php
141 echo $cname;
142 ?>
143
144 <div style="float:right; font-size:20px;text-align:right;">
145
146 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
147 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
148 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
149
150 </div>
151 </h2>
152 </div>
153 <div>
154 <ul class="nav nav-tabs">
155 <li class="active"><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
156 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
157 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
158 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
159 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
160 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
161 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
162 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
163 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
164 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
165
166 </ul>
167 <div class="tab-content">
168 <div class="tab-pane active" role="tabpanel" id="tab-1">
169
170 <p>
171 <div class="table-responsive" >
172 <!--****************************************************************************-->
173
174 <div class="container-fluid">
175 <div class="row">
176 <div class="col-lg-4 col-lg-offset-4">
177 <div class="panel panel-primary">
178 <div class="panel-heading">Edit User</div>
179
180 <!-- /.panel-heading -->
181 <div class="panel-body">
182 <div class="table">
183 <!--------------------form------------------->
184 <form method="post">
185 <tbody>
186 <tr>
187 <center>
188
189 <div class="form-group input-group">
190 <label class="col-sm-2 control-label">Firstname</label>
191 <input type="text" class="form-control" id="fname" name="fname" value="<?php echo $fname?>" placeholder="Firstname"required autofocus>
192 </div>
193
194 <div class="form-group input-group">
195 <label class="col-sm-2 control-label">Lastname</label>
196 <input type="text" class="form-control" id="lname" name="lname" value="<?php echo $lname?>" placeholder="Lastname"required>
197 </div>
198
199 <div class="form-group input-group">
200 <label class="col-sm-2 control-label">Username</label>
201 <input type="text" class="form-control" id="username" name="username" value="<?php echo $uname?>" placeholder="Username"required>
202 </div>
203
204 <div class="form-group input-group">
205 <label class="col-sm-2 control-label">Username</label>
206 <input type="text" class="form-control" id="email" name="email" value="<?php echo $email?>" placeholder="Username"required>
207 </div>
208
209 <div class="form-group input-group">
210 <label class="col-sm-2 control-label">Password</label>
211 <input type="password" class="form-control" id="password" name="password" placeholder="Password"required>
212 </div>
213
214
215
216 <div class="col-md-11">
217 <button name="update" class="btn btn-success">Update</button>
218 <a button id="cancel" name="cancel" class="btn btn-danger" href="manage_account.php" >Cancel</button></a>
219 </div>
220 <br>
221 <br>
222 <br>
223 <br>
224
225 </tr>
226 </tbody>
227 </div>
228 </center>
229 </form>
230
231 </div>
232 </div>
233 </div>
234 </div>
235 </div>
236 </div>
237
238 <!--*********************************************************************************-->
239 <div class="col-md-12" style="background-color:#526F35; position:fixed;bottom:0px;">
240 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
241 </div>
242
243 <script src="assets/js/jquery.min.js"></script>
244 <script src="assets/js/affix.js"></script>
245 <script src="assets/js/alert.js"></script>
246 <script src="assets/js/alert1.js"></script>
247 <script src="assets/js/bootstrap.js"></script>
248 <script src="assets/js/bootstrap.min.js"></script>
249 <script src="assets/js/bootstrap-datepicker.js"></script>
250 <script src="assets/js/bootstrap-wysihtml5.js"></script>
251 <script src="assets/js/button.js"></script>
252 <script src="assets/js/carousel.js"></script>
253 <script src="assets/js/chosen.jquery.min.js"></script>
254 <script src="assets/js/ckeditor.js"></script>
255 <script src="assets/js/collapse.js"></script>
256 <script src="assets/js/color.js"></script>
257 <script src="assets/js/dropdown.js"></script>
258 <script src="assets/js/DT_bootstrap.js"></script>
259 <script src="assets/js/dynamic.js"></script>
260 <script src="assets/js/ie-emulation-modes-warning.js"></script>
261 <script src="assets/js/jquery.dataTables.js"></script>
262 <script src="assets/js/jquery.dataTables.min.js"></script>
263 <script src="assets/js/jquery.dialog.js"></script>
264 <script src="assets/js/jquery.hoverdir.js"></script>
265 <script src="assets/js/jquery.jgrowl.js"></script>
266 <script src="assets/js/jquery.knob.js"></script>
267 <script src="assets/js/jquery.uniform.min.js"></script>
268 <script src="assets/js/jquery-1.8.3.min.js"></script>
269 <script src="assets/js/jquery-1.9.1.js"></script>
270 <script src="assets/js/jquery-1.9.1.min.js"></script>
271 <script src="assets/js/jquery-1.10.2.js"></script>
272 <script src="assets/js/jquery-1.11.0.js"></script>
273 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
274 <script src="assets/js/jquery-ui-1.10.3.js"></script>
275 <script src="assets/js/modal.js"></script>
276 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
277 <script src="assets/js/myjquery.js"></script>
278 <script src="assets/js/myjquery1.js"></script>
279 <script src="assets/js/npm.js"></script>
280 <script src="assets/js/popover.js"></script>
281 <script src="assets/js/profile.js"></script>
282 <script src="assets/js/raphael-min.js"></script>
283 <script src="assets/js/sb-admin-2.js"></script>
284 <script src="assets/js/scripts.js"></script>
285 <script src="assets/js/scrollspy.js"></script>
286 <script src="assets/js/tab.js"></script>
287 <script src="assets/js/tooltip.js"></script>
288 <script src="assets/js/transition.js"></script>
289 <script src="assets/js/wysihtml5-0.3.0.js"></script>
290 <script src="assets/js/slideshow.js"></script>
291
292 <script language="javascript" type="text/javascript">
293 $(window).load(function()
294 {
295 $('#loading').hide();
296 });
297 </script>
298
299 <script>
300 $(document).ready(function(){
301 $('.dropdown-submenu a.test').on("click", function(e){
302 $(this).next('ul').toggle();
303 e.stopPropagation();
304 e.preventDefault();
305 });
306 });
307 </script>
308 </body>
309
310 </html>